﻿using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;

namespace BaoShouTangServer.Models
{
    public partial class RecordOutQ
    {
        public RecordOutQ()
        { }
        #region Model
        private long _id;
        private int _brdflag;
        private string _cvouchtype;
        private string _csysbarcode;
        private string _cwhcode;
        private DateTime _ddate;
        private string _ccode;
        private string _crdcode;
        private string _cdepcode;
        private string _cpersoncode;
        private string _cprobatch;
        private string _chandler;
        private string _cmemo;
        private string _caccounter;
        private string _cmaker;
        private string _cdefine1;
        private string _cdefine2;
        private string _cdefine3;
        private DateTime? _cdefine4;
        private int? _cdefine5;
        private DateTime? _cdefine6;
        private decimal? _cdefine7;
        private string _cdefine8;
        private string _cdefine9;
        private string _cdefine10;
        private string _cwhname;
        private string _cdepname;
        private string _cpersonname;
        private string _crdname;
        private string _csource;
        private string _cbustype;
        private string _cbuscode;
        private DateTime? _dveridate;
        private DateTime? _darvdate;
        private string _cchkcode;
        private DateTime? _dchkdate;
        private string _cchkperson;
        private bool _bisstqc;
        private int? _vt_id;
        private string _cdefine11;
        private string _cdefine12;
        private string _cdefine13;
        private string _cdefine14;
        private int? _cdefine15;
        private decimal? _cdefine16;
        private decimal? _imquantity;
        private string _cpspcode;
        private string _cinvname;
        private string _cinvstd;
        private string _cinvaddcode;
        private string _hcinvdefine1;
        private string _hcinvdefine2;
        private string _hcinvdefine3;
        private string _hcinvdefine4;
        private string _hcinvdefine5;
        private string _hcinvdefine6;
        private string _hcinvdefine7;
        private string _hcinvdefine8;
        private string _hcinvdefine9;
        private string _hcinvdefine10;
        private int? _hcinvdefine11;
        private int? _hcinvdefine12;
        private decimal? _hcinvdefine13;
        private decimal? _hcinvdefine14;
        private DateTime? _hcinvdefine15;
        private DateTime? _hcinvdefine16;
        private string _cmpocode;
        private bool _bpufirst;
        private bool _biafirst;
        private string _cvencode;
        private string _cvenabbname;
        private int? _ivenauthid;
        private long _ipurorderid;
        private int? _iproorderid;
        private int _biscomplement;
        private int? _ipspauthid;
        private string _cproinvaddcode;
        private int? _ireturncount;
        private int? _iverifystate;
        private int? _iswfcontrolled;
        private string _ufts;
        private string _cmodifyperson;
        private DateTime? _dmodifydate;
        private DateTime? _dnmaketime;
        private DateTime? _dnmodifytime;
        private DateTime? _dnverifytime;
        private int? _bomfirst;
        private int _bmotran;
        private string _chinvsn;
        private string _isourcerowno;
        private int? _iflowid;
        private string _cflowname;
        private bool _bhyvouch;
        private int? _iprintcount;
        private string _ccurrentauditor;
        private string _cfactorycode;
        private string _cfactoryname;
        private string _cchecksignflag;
        /// <summary>
        /// 
        /// </summary>
        public long id
        {
            set { _id = value; }
            get { return _id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int brdflag
        {
            set { _brdflag = value; }
            get { return _brdflag; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvouchtype
        {
            set { _cvouchtype = value; }
            get { return _cvouchtype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csysbarcode
        {
            set { _csysbarcode = value; }
            get { return _csysbarcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cwhcode
        {
            set { _cwhcode = value; }
            get { return _cwhcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime ddate
        {
            set { _ddate = value; }
            get { return _ddate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ccode
        {
            set { _ccode = value; }
            get { return _ccode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string crdcode
        {
            set { _crdcode = value; }
            get { return _crdcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdepcode
        {
            set { _cdepcode = value; }
            get { return _cdepcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpersoncode
        {
            set { _cpersoncode = value; }
            get { return _cpersoncode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cprobatch
        {
            set { _cprobatch = value; }
            get { return _cprobatch; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string chandler
        {
            set { _chandler = value; }
            get { return _chandler; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmemo
        {
            set { _cmemo = value; }
            get { return _cmemo; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string caccounter
        {
            set { _caccounter = value; }
            get { return _caccounter; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmaker
        {
            set { _cmaker = value; }
            get { return _cmaker; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine1
        {
            set { _cdefine1 = value; }
            get { return _cdefine1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine2
        {
            set { _cdefine2 = value; }
            get { return _cdefine2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine3
        {
            set { _cdefine3 = value; }
            get { return _cdefine3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine4
        {
            set { _cdefine4 = value; }
            get { return _cdefine4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine5
        {
            set { _cdefine5 = value; }
            get { return _cdefine5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? cdefine6
        {
            set { _cdefine6 = value; }
            get { return _cdefine6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine7
        {
            set { _cdefine7 = value; }
            get { return _cdefine7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine8
        {
            set { _cdefine8 = value; }
            get { return _cdefine8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine9
        {
            set { _cdefine9 = value; }
            get { return _cdefine9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine10
        {
            set { _cdefine10 = value; }
            get { return _cdefine10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cwhname
        {
            set { _cwhname = value; }
            get { return _cwhname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdepname
        {
            set { _cdepname = value; }
            get { return _cdepname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpersonname
        {
            set { _cpersonname = value; }
            get { return _cpersonname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string crdname
        {
            set { _crdname = value; }
            get { return _crdname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string csource
        {
            set { _csource = value; }
            get { return _csource; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbustype
        {
            set { _cbustype = value; }
            get { return _cbustype; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cbuscode
        {
            set { _cbuscode = value; }
            get { return _cbuscode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dveridate
        {
            set { _dveridate = value; }
            get { return _dveridate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? darvdate
        {
            set { _darvdate = value; }
            get { return _darvdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cchkcode
        {
            set { _cchkcode = value; }
            get { return _cchkcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dchkdate
        {
            set { _dchkdate = value; }
            get { return _dchkdate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cchkperson
        {
            set { _cchkperson = value; }
            get { return _cchkperson; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bisstqc
        {
            set { _bisstqc = value; }
            get { return _bisstqc; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? vt_id
        {
            set { _vt_id = value; }
            get { return _vt_id; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine11
        {
            set { _cdefine11 = value; }
            get { return _cdefine11; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine12
        {
            set { _cdefine12 = value; }
            get { return _cdefine12; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine13
        {
            set { _cdefine13 = value; }
            get { return _cdefine13; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cdefine14
        {
            set { _cdefine14 = value; }
            get { return _cdefine14; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? cdefine15
        {
            set { _cdefine15 = value; }
            get { return _cdefine15; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? cdefine16
        {
            set { _cdefine16 = value; }
            get { return _cdefine16; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? imquantity
        {
            set { _imquantity = value; }
            get { return _imquantity; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cpspcode
        {
            set { _cpspcode = value; }
            get { return _cpspcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvname
        {
            set { _cinvname = value; }
            get { return _cinvname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvstd
        {
            set { _cinvstd = value; }
            get { return _cinvstd; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cinvaddcode
        {
            set { _cinvaddcode = value; }
            get { return _cinvaddcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine1
        {
            set { _hcinvdefine1 = value; }
            get { return _hcinvdefine1; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine2
        {
            set { _hcinvdefine2 = value; }
            get { return _hcinvdefine2; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine3
        {
            set { _hcinvdefine3 = value; }
            get { return _hcinvdefine3; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine4
        {
            set { _hcinvdefine4 = value; }
            get { return _hcinvdefine4; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine5
        {
            set { _hcinvdefine5 = value; }
            get { return _hcinvdefine5; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine6
        {
            set { _hcinvdefine6 = value; }
            get { return _hcinvdefine6; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine7
        {
            set { _hcinvdefine7 = value; }
            get { return _hcinvdefine7; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine8
        {
            set { _hcinvdefine8 = value; }
            get { return _hcinvdefine8; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine9
        {
            set { _hcinvdefine9 = value; }
            get { return _hcinvdefine9; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string hcinvdefine10
        {
            set { _hcinvdefine10 = value; }
            get { return _hcinvdefine10; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? hcinvdefine11
        {
            set { _hcinvdefine11 = value; }
            get { return _hcinvdefine11; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? hcinvdefine12
        {
            set { _hcinvdefine12 = value; }
            get { return _hcinvdefine12; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? hcinvdefine13
        {
            set { _hcinvdefine13 = value; }
            get { return _hcinvdefine13; }
        }
        /// <summary>
        /// 
        /// </summary>
        public decimal? hcinvdefine14
        {
            set { _hcinvdefine14 = value; }
            get { return _hcinvdefine14; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? hcinvdefine15
        {
            set { _hcinvdefine15 = value; }
            get { return _hcinvdefine15; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? hcinvdefine16
        {
            set { _hcinvdefine16 = value; }
            get { return _hcinvdefine16; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmpocode
        {
            set { _cmpocode = value; }
            get { return _cmpocode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bpufirst
        {
            set { _bpufirst = value; }
            get { return _bpufirst; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool biafirst
        {
            set { _biafirst = value; }
            get { return _biafirst; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvencode
        {
            set { _cvencode = value; }
            get { return _cvencode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cvenabbname
        {
            set { _cvenabbname = value; }
            get { return _cvenabbname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ivenauthid
        {
            set { _ivenauthid = value; }
            get { return _ivenauthid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public long ipurorderid
        {
            set { _ipurorderid = value; }
            get { return _ipurorderid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iproorderid
        {
            set { _iproorderid = value; }
            get { return _iproorderid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int biscomplement
        {
            set { _biscomplement = value; }
            get { return _biscomplement; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ipspauthid
        {
            set { _ipspauthid = value; }
            get { return _ipspauthid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cproinvaddcode
        {
            set { _cproinvaddcode = value; }
            get { return _cproinvaddcode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? ireturncount
        {
            set { _ireturncount = value; }
            get { return _ireturncount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iverifystate
        {
            set { _iverifystate = value; }
            get { return _iverifystate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iswfcontrolled
        {
            set { _iswfcontrolled = value; }
            get { return _iswfcontrolled; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ufts
        {
            set { _ufts = value; }
            get { return _ufts; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cmodifyperson
        {
            set { _cmodifyperson = value; }
            get { return _cmodifyperson; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dmodifydate
        {
            set { _dmodifydate = value; }
            get { return _dmodifydate; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dnmaketime
        {
            set { _dnmaketime = value; }
            get { return _dnmaketime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dnmodifytime
        {
            set { _dnmodifytime = value; }
            get { return _dnmodifytime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public DateTime? dnverifytime
        {
            set { _dnverifytime = value; }
            get { return _dnverifytime; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? bomfirst
        {
            set { _bomfirst = value; }
            get { return _bomfirst; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int bmotran
        {
            set { _bmotran = value; }
            get { return _bmotran; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string chinvsn
        {
            set { _chinvsn = value; }
            get { return _chinvsn; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string isourcerowno
        {
            set { _isourcerowno = value; }
            get { return _isourcerowno; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iflowid
        {
            set { _iflowid = value; }
            get { return _iflowid; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cflowname
        {
            set { _cflowname = value; }
            get { return _cflowname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public bool bhyvouch
        {
            set { _bhyvouch = value; }
            get { return _bhyvouch; }
        }
        /// <summary>
        /// 
        /// </summary>
        public int? iPrintCount
        {
            set { _iprintcount = value; }
            get { return _iprintcount; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string ccurrentauditor
        {
            set { _ccurrentauditor = value; }
            get { return _ccurrentauditor; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfactorycode
        {
            set { _cfactorycode = value; }
            get { return _cfactorycode; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cfactoryname
        {
            set { _cfactoryname = value; }
            get { return _cfactoryname; }
        }
        /// <summary>
        /// 
        /// </summary>
        public string cchecksignflag
        {
            set { _cchecksignflag = value; }
            get { return _cchecksignflag; }
        }
        #endregion Model


        #region  Method

       

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(string tablename)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into " + tablename + " (");
            strSql.Append("id,brdflag,cvouchtype,csysbarcode,cwhcode,ddate,ccode,crdcode,cdepcode,cpersoncode,cprobatch,chandler,cmemo,caccounter,cmaker,cdefine1,cdefine2,cdefine3,cdefine4,cdefine5,cdefine6,cdefine7,cdefine8,cdefine9,cdefine10,cwhname,cdepname,cpersonname,crdname,csource,cbustype,cbuscode,dveridate,darvdate,cchkcode,dchkdate,cchkperson,bisstqc,vt_id,cdefine11,cdefine12,cdefine13,cdefine14,cdefine15,cdefine16,imquantity,cpspcode,cinvname,cinvstd,cinvaddcode,hcinvdefine1,hcinvdefine2,hcinvdefine3,hcinvdefine4,hcinvdefine5,hcinvdefine6,hcinvdefine7,hcinvdefine8,hcinvdefine9,hcinvdefine10,hcinvdefine11,hcinvdefine12,hcinvdefine13,hcinvdefine14,hcinvdefine15,hcinvdefine16,cmpocode,bpufirst,biafirst,cvencode,cvenabbname,ivenauthid,ipurorderid,iproorderid,biscomplement,ipspauthid,cproinvaddcode,ireturncount,iverifystate,iswfcontrolled,ufts,cmodifyperson,dmodifydate,dnmaketime,dnmodifytime,dnverifytime,bomfirst,bmotran,chinvsn,isourcerowno,iflowid,cflowname,bhyvouch,iPrintCount,ccurrentauditor,cfactorycode,cfactoryname,cchecksignflag)");
            strSql.Append(" values (");
            strSql.Append("@id,@brdflag,@cvouchtype,@csysbarcode,@cwhcode,@ddate,@ccode,@crdcode,@cdepcode,@cpersoncode,@cprobatch,@chandler,@cmemo,@caccounter,@cmaker,@cdefine1,@cdefine2,@cdefine3,@cdefine4,@cdefine5,@cdefine6,@cdefine7,@cdefine8,@cdefine9,@cdefine10,@cwhname,@cdepname,@cpersonname,@crdname,@csource,@cbustype,@cbuscode,@dveridate,@darvdate,@cchkcode,@dchkdate,@cchkperson,@bisstqc,@vt_id,@cdefine11,@cdefine12,@cdefine13,@cdefine14,@cdefine15,@cdefine16,@imquantity,@cpspcode,@cinvname,@cinvstd,@cinvaddcode,@hcinvdefine1,@hcinvdefine2,@hcinvdefine3,@hcinvdefine4,@hcinvdefine5,@hcinvdefine6,@hcinvdefine7,@hcinvdefine8,@hcinvdefine9,@hcinvdefine10,@hcinvdefine11,@hcinvdefine12,@hcinvdefine13,@hcinvdefine14,@hcinvdefine15,@hcinvdefine16,@cmpocode,@bpufirst,@biafirst,@cvencode,@cvenabbname,@ivenauthid,@ipurorderid,@iproorderid,@biscomplement,@ipspauthid,@cproinvaddcode,@ireturncount,@iverifystate,@iswfcontrolled,@ufts,@cmodifyperson,@dmodifydate,@dnmaketime,@dnmodifytime,@dnverifytime,@bomfirst,@bmotran,@chinvsn,@isourcerowno,@iflowid,@cflowname,@bhyvouch,@iPrintCount,@ccurrentauditor,@cfactorycode,@cfactoryname,@cchecksignflag)");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.BigInt,8),
                    new SqlParameter("@brdflag", SqlDbType.TinyInt,1),
                    new SqlParameter("@cvouchtype", SqlDbType.NVarChar,2),
                    new SqlParameter("@csysbarcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@cwhcode", SqlDbType.NVarChar,10),
                    new SqlParameter("@ddate", SqlDbType.DateTime),
                    new SqlParameter("@ccode", SqlDbType.NVarChar,30),
                    new SqlParameter("@crdcode", SqlDbType.NVarChar,5),
                    new SqlParameter("@cdepcode", SqlDbType.NVarChar,12),
                    new SqlParameter("@cpersoncode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cprobatch", SqlDbType.NVarChar,60),
                    new SqlParameter("@chandler", SqlDbType.NVarChar,20),
                    new SqlParameter("@cmemo", SqlDbType.NVarChar,255),
                    new SqlParameter("@caccounter", SqlDbType.NVarChar,20),
                    new SqlParameter("@cmaker", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdefine4", SqlDbType.DateTime),
                    new SqlParameter("@cdefine5", SqlDbType.Int,4),
                    new SqlParameter("@cdefine6", SqlDbType.DateTime),
                    new SqlParameter("@cdefine7", SqlDbType.Float,8),
                    new SqlParameter("@cdefine8", SqlDbType.NVarChar,4),
                    new SqlParameter("@cdefine9", SqlDbType.NVarChar,8),
                    new SqlParameter("@cdefine10", SqlDbType.NVarChar,60),
                    new SqlParameter("@cwhname", SqlDbType.NVarChar,20),
                    new SqlParameter("@cdepname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cpersonname", SqlDbType.NVarChar,40),
                    new SqlParameter("@crdname", SqlDbType.NVarChar,12),
                    new SqlParameter("@csource", SqlDbType.NVarChar,50),
                    new SqlParameter("@cbustype", SqlDbType.NVarChar,12),
                    new SqlParameter("@cbuscode", SqlDbType.NVarChar,30),
                    new SqlParameter("@dveridate", SqlDbType.DateTime),
                    new SqlParameter("@darvdate", SqlDbType.DateTime),
                    new SqlParameter("@cchkcode", SqlDbType.NVarChar,30),
                    new SqlParameter("@dchkdate", SqlDbType.DateTime),
                    new SqlParameter("@cchkperson", SqlDbType.NVarChar,40),
                    new SqlParameter("@bisstqc", SqlDbType.Bit,1),
                    new SqlParameter("@vt_id", SqlDbType.Int,4),
                    new SqlParameter("@cdefine11", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine12", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine13", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine14", SqlDbType.NVarChar,120),
                    new SqlParameter("@cdefine15", SqlDbType.Int,4),
                    new SqlParameter("@cdefine16", SqlDbType.Float,8),
                    new SqlParameter("@imquantity", SqlDbType.Float,8),
                    new SqlParameter("@cpspcode", SqlDbType.NVarChar,60),
                    new SqlParameter("@cinvname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cinvstd", SqlDbType.NVarChar,255),
                    new SqlParameter("@cinvaddcode", SqlDbType.NVarChar,255),
                    new SqlParameter("@hcinvdefine1", SqlDbType.NVarChar,20),
                    new SqlParameter("@hcinvdefine2", SqlDbType.NVarChar,20),
                    new SqlParameter("@hcinvdefine3", SqlDbType.NVarChar,20),
                    new SqlParameter("@hcinvdefine4", SqlDbType.NVarChar,60),
                    new SqlParameter("@hcinvdefine5", SqlDbType.NVarChar,60),
                    new SqlParameter("@hcinvdefine6", SqlDbType.NVarChar,60),
                    new SqlParameter("@hcinvdefine7", SqlDbType.NVarChar,120),
                    new SqlParameter("@hcinvdefine8", SqlDbType.NVarChar,120),
                    new SqlParameter("@hcinvdefine9", SqlDbType.NVarChar,120),
                    new SqlParameter("@hcinvdefine10", SqlDbType.NVarChar,120),
                    new SqlParameter("@hcinvdefine11", SqlDbType.Int,4),
                    new SqlParameter("@hcinvdefine12", SqlDbType.Int,4),
                    new SqlParameter("@hcinvdefine13", SqlDbType.Float,8),
                    new SqlParameter("@hcinvdefine14", SqlDbType.Float,8),
                    new SqlParameter("@hcinvdefine15", SqlDbType.DateTime),
                    new SqlParameter("@hcinvdefine16", SqlDbType.DateTime),
                    new SqlParameter("@cmpocode", SqlDbType.NVarChar,30),
                    new SqlParameter("@bpufirst", SqlDbType.Bit,1),
                    new SqlParameter("@biafirst", SqlDbType.Bit,1),
                    new SqlParameter("@cvencode", SqlDbType.NVarChar,20),
                    new SqlParameter("@cvenabbname", SqlDbType.NVarChar,60),
                    new SqlParameter("@ivenauthid", SqlDbType.Int,4),
                    new SqlParameter("@ipurorderid", SqlDbType.BigInt,8),
                    new SqlParameter("@iproorderid", SqlDbType.Int,4),
                    new SqlParameter("@biscomplement", SqlDbType.SmallInt,2),
                    new SqlParameter("@ipspauthid", SqlDbType.Int,4),
                    new SqlParameter("@cproinvaddcode", SqlDbType.NVarChar,255),
                    new SqlParameter("@ireturncount", SqlDbType.Int,4),
                    new SqlParameter("@iverifystate", SqlDbType.Int,4),
                    new SqlParameter("@iswfcontrolled", SqlDbType.Int,4),
                    new SqlParameter("@ufts", SqlDbType.NChar,30),
                    new SqlParameter("@cmodifyperson", SqlDbType.NVarChar,50),
                    new SqlParameter("@dmodifydate", SqlDbType.DateTime),
                    new SqlParameter("@dnmaketime", SqlDbType.DateTime),
                    new SqlParameter("@dnmodifytime", SqlDbType.DateTime),
                    new SqlParameter("@dnverifytime", SqlDbType.DateTime),
                    new SqlParameter("@bomfirst", SqlDbType.TinyInt,1),
                    new SqlParameter("@bmotran", SqlDbType.TinyInt,1),
                    new SqlParameter("@chinvsn", SqlDbType.NVarChar,60),
                    new SqlParameter("@isourcerowno", SqlDbType.VarChar,60),
                    new SqlParameter("@iflowid", SqlDbType.Int,4),
                    new SqlParameter("@cflowname", SqlDbType.NVarChar,40),
                    new SqlParameter("@bhyvouch", SqlDbType.Bit,1),
                    new SqlParameter("@iPrintCount", SqlDbType.Int,4),
                    new SqlParameter("@ccurrentauditor", SqlDbType.NVarChar,200),
                    new SqlParameter("@cfactorycode", SqlDbType.NVarChar,50),
                    new SqlParameter("@cfactoryname", SqlDbType.NVarChar,255),
                    new SqlParameter("@cchecksignflag", SqlDbType.NVarChar,36)};
            parameters[0].Value = id;
            parameters[1].Value = brdflag;
            parameters[2].Value = cvouchtype;
            parameters[3].Value = csysbarcode;
            parameters[4].Value = cwhcode;
            parameters[5].Value = ddate;
            parameters[6].Value = ccode;
            parameters[7].Value = crdcode;
            parameters[8].Value = cdepcode;
            parameters[9].Value = cpersoncode;
            parameters[10].Value = cprobatch;
            parameters[11].Value = chandler;
            parameters[12].Value = cmemo;
            parameters[13].Value = caccounter;
            parameters[14].Value = cmaker;
            parameters[15].Value = cdefine1;
            parameters[16].Value = cdefine2;
            parameters[17].Value = cdefine3;
            parameters[18].Value = cdefine4;
            parameters[19].Value = cdefine5;
            parameters[20].Value = cdefine6;
            parameters[21].Value = cdefine7;
            parameters[22].Value = cdefine8;
            parameters[23].Value = cdefine9;
            parameters[24].Value = cdefine10;
            parameters[25].Value = cwhname;
            parameters[26].Value = cdepname;
            parameters[27].Value = cpersonname;
            parameters[28].Value = crdname;
            parameters[29].Value = csource;
            parameters[30].Value = cbustype;
            parameters[31].Value = cbuscode;
            parameters[32].Value = dveridate;
            parameters[33].Value = darvdate;
            parameters[34].Value = cchkcode;
            parameters[35].Value = dchkdate;
            parameters[36].Value = cchkperson;
            parameters[37].Value = bisstqc;
            parameters[38].Value = vt_id;
            parameters[39].Value = cdefine11;
            parameters[40].Value = cdefine12;
            parameters[41].Value = cdefine13;
            parameters[42].Value = cdefine14;
            parameters[43].Value = cdefine15;
            parameters[44].Value = cdefine16;
            parameters[45].Value = imquantity;
            parameters[46].Value = cpspcode;
            parameters[47].Value = cinvname;
            parameters[48].Value = cinvstd;
            parameters[49].Value = cinvaddcode;
            parameters[50].Value = hcinvdefine1;
            parameters[51].Value = hcinvdefine2;
            parameters[52].Value = hcinvdefine3;
            parameters[53].Value = hcinvdefine4;
            parameters[54].Value = hcinvdefine5;
            parameters[55].Value = hcinvdefine6;
            parameters[56].Value = hcinvdefine7;
            parameters[57].Value = hcinvdefine8;
            parameters[58].Value = hcinvdefine9;
            parameters[59].Value = hcinvdefine10;
            parameters[60].Value = hcinvdefine11;
            parameters[61].Value = hcinvdefine12;
            parameters[62].Value = hcinvdefine13;
            parameters[63].Value = hcinvdefine14;
            parameters[64].Value = hcinvdefine15;
            parameters[65].Value = hcinvdefine16;
            parameters[66].Value = cmpocode;
            parameters[67].Value = bpufirst;
            parameters[68].Value = biafirst;
            parameters[69].Value = cvencode;
            parameters[70].Value = cvenabbname;
            parameters[71].Value = ivenauthid;
            parameters[72].Value = ipurorderid;
            parameters[73].Value = iproorderid;
            parameters[74].Value = biscomplement;
            parameters[75].Value = ipspauthid;
            parameters[76].Value = cproinvaddcode;
            parameters[77].Value = ireturncount;
            parameters[78].Value = iverifystate;
            parameters[79].Value = iswfcontrolled;
            parameters[80].Value = ufts;
            parameters[81].Value = cmodifyperson;
            parameters[82].Value = dmodifydate;
            parameters[83].Value = dnmaketime;
            parameters[84].Value = dnmodifytime;
            parameters[85].Value = dnverifytime;
            parameters[86].Value = bomfirst;
            parameters[87].Value = bmotran;
            parameters[88].Value = chinvsn;
            parameters[89].Value = isourcerowno;
            parameters[90].Value = iflowid;
            parameters[91].Value = cflowname;
            parameters[92].Value = bhyvouch;
            parameters[93].Value = iPrintCount;
            parameters[94].Value = ccurrentauditor;
            parameters[95].Value = cfactorycode;
            parameters[96].Value = cfactoryname;
            parameters[97].Value = cchecksignflag;

          return  DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        #endregion  Method
    }
}